There are two schemas D1 and D2 which have the same table with different data called Hotels.
I need to get the data list of under 'Vista' name, ID,P-Email, D-Email, X-Email and Z-Email from those two tables. Primary Key is ID. What is the query for this?
Nimasha Jayathunga :
USE D1;\nSelect ID, P-Email, D-Email, X-Email, Z-Email from Hotels where Name ='Vista';\n\nUSE D2;\nSelect ID, P-Email, D-Email, X-Email, Z-Email from Hotels where Name ='Vista';",
2020-02-23T17:24:15